Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

gsm_scm_xref table — gsmsx

This table defines the mapping between data in the Repository and each external SCM tool being used. Examples of the data that is mapped are object types and product modules. This allows the external SCM tool to use different codes than those used in Progress Dynamics. It also allows multiple codes in Progress Dynamics to share a common code in the external SCM tool. For example, many product modules and object types in Progress Dynamics could point at common modules and subtypes in an SCM tool such as Roundtable.

The scm_foreign_key field is the field in the external SCM tool. It is a character field for maximum portability. You should use APIs to provide lookup lists for values in the external SCM tool. You must set up data in this table for SCM integration to function, so that it is clear what data is mapped to what. If it is a one-to-one mapping, then tools can be used to synchronize the data and set it up automatically.

Table 3–15 lists the table’s FLA, fields, and foreign keys.

Table 3–15: gsm_scm_xref table information 

Table FLA	Fields (data type)	Foreign keys
gsmsx	scm_xref_obj (Decimal) scm_tool_obj (Decimal) owning_entity_mnemonic (Character) owning_reference (Character) owning_obj (Decimal) scm_foreign_key (Character)	scm_tool_obj

Table 3–16 gives details of the table’s indexes.

Table 3–16: gsm_scm_xref index information 

Index name	Elements	Type
XPKgsm_scm_xref	scm_xref_obj	Primary Unique
XAK1gsm_scm_xref	scm_tool_obj owning_entity_mnemonic owning_reference	Unique
XIE1gsm_scm_xref	owning_entity_mnemonic	Nonunique
XIE2gsm_scm_xref	owning_obj	Nonunique
XIE3gsm_scm_xref	scm_foreign_key	Nonunique
XIE4gsm_scm_xref	owning_reference	Nonunique